[ROOT] dt FactResellerSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS *
37 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | EUR | GBP | USD |
|---|---|---|---|---|---|---|
| 2021-07 | 845K | 0 | 235K | 0 | 0 | 610K |
| 2021-10 | 713K | 0 | 164K | 0 | 0 | 549K |
| 2023-02 | 2.9M | 0 | 468K | 10.3K | 112K | 2.3M |
| 2022-04 | 2.4M | 0 | 638K | 42.4K | 81K | 1.6M |
| 2021-06 | 1.2M | 0 | 206K | 0 | 0 | 960K |
| 2023-04 | 2.7M | 49.8K | 501K | 204K | 152K | 1.8M |
| 2022-06 | 2.9M | 0 | 564K | 0 | 208K | 2.1M |
| 2023-07 | 2.3M | 55K | 402K | 204K | 116K | 1.5M |
| 2022-12 | 1.6M | 0 | 394K | 0 | 116K | 1.1M |
| 2023-08 | 3.5M | 124K | 433K | 285K | 199K | 2.4M |
| 2023-10 | 1.7M | 63K | 237K | 124K | 81K | 1.2M |
| 2021-04 | 489K | 0 | 115K | 0 | 0 | 374K |
| 2023-09 | 3.5M | 217K | 712K | 161K | 418K | 2.0M |
| 2022-03 | 1.0M | 0 | 178K | 0 | 0 | 824K |
| 2022-09 | 2.2M | 0 | 489K | 0 | 166K | 1.5M |
| 2022-11 | 2.4M | 0 | 354K | 10.7K | 121K | 1.9M |
| 2021-11 | 1.9M | 0 | 277K | 0 | 0 | 1.6M |
| 2023-01 | 1.9M | 0 | 439K | 11.8K | 48.1K | 1.4M |
| 2021-08 | 2.3M | 0 | 382K | 0 | 0 | 1.9M |
| 2023-03 | 2.0M | 0 | 443K | 0 | 131K | 1.4M |
| 2021-12 | 1.5M | 0 | 335K | 0 | 0 | 1.1M |
| 2022-08 | 3.1M | 0 | 510K | 8.6K | 141K | 2.4M |
| 2022-05 | 3.6M | 0 | 658K | 10.5K | 183K | 2.7M |
| 2024-02 | 3.3M | 116K | 395K | 258K | 199K | 2.3M |
| 2022-10 | 1.3M | 0 | 260K | 4.8K | 36.8K | 1.0M |
| 2024-03 | 3.4M | 232K | 585K | 136K | 426K | 2.0M |
| 2023-11 | 2.7M | 77K | 323K | 192K | 151K | 2.0M |
| 2021-05 | 1.5M | 0 | 317K | 0 | 0 | 1.2M |
| 2023-12 | 2.7M | 201K | 465K | 135K | 311K | 1.6M |
| 2021-09 | 1.7M | 0 | 259K | 0 | 0 | 1.4M |
| 2022-01 | 883K | 0 | 228K | 0 | 0 | 655K |
| 2022-02 | 2.3M | 0 | 385K | 0 | 0 | 1.9M |
| 2022-07 | 1.8M | 0 | 397K | 18.7K | 63K | 1.3M |
| 2023-05 | 4.2M | 134K | 567K | 345K | 213K | 3.0M |
| 2023-06 | 4.0M | 267K | 677K | 126K | 496K | 2.5M |
| 2024-01 | 2.2M | 59K | 386K | 187K | 110K | 1.5M |
| _SUM | 80M | 1.6M | 14.4M | 2.5M | 4.3M | 58M |
Generated 2024-05-16 05:47:34.588 UTC